Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 42931 |
| Missing cells | 63506 |
| Missing cells (%) | 8.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 5.6 MiB |
| Average record size in memory | 136.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Text | 4 |
| Categorical | 2 |
| DateTime | 1 |
host_id is highly overall correlated with id | High correlation |
id is highly overall correlated with host_id | High correlation |
latitude is highly overall correlated with neighbourhood_group | High correlation |
longitude is highly overall correlated with neighbourhood_group | High correlation |
minimum_nights is highly overall correlated with number_of_reviews_ltm and 1 other fields | High correlation |
neighbourhood_group is highly overall correlated with latitude and 1 other fields | High correlation |
number_of_reviews is highly overall correlated with number_of_reviews_ltm and 1 other fields | High correlation |
number_of_reviews_ltm is highly overall correlated with minimum_nights and 2 other fields | High correlation |
reviews_per_month is highly overall correlated with minimum_nights and 2 other fields | High correlation |
last_review has 10304 (24.0%) missing values | Missing |
reviews_per_month has 10304 (24.0%) missing values | Missing |
detailed_location has 42881 (99.9%) missing values | Missing |
price is highly skewed (γ1 = 81.45449106) | Skewed |
id has unique values | Unique |
number_of_reviews has 10304 (24.0%) zeros | Zeros |
number_of_reviews_ltm has 21470 (50.0%) zeros | Zeros |
Reproduction
| Analysis started | 2024-05-07 06:13:57.996604 |
|---|---|
| Analysis finished | 2024-05-07 06:14:32.812553 |
| Duration | 34.82 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
id
Real number (ℝ)
HIGH CORRELATION  UNIQUE 
| Distinct | 42931 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2227724 × 1017 |
| Minimum | 2595 |
|---|---|
| Maximum | 8.4046605 × 1017 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 335.5 KiB |
Quantile statistics
| Minimum | 2595 |
|---|---|
| 5-th percentile | 3039221 |
| Q1 | 19404736 |
| median | 43374815 |
| Q3 | 6.305016 × 1017 |
| 95-th percentile | 8.076607 × 1017 |
| Maximum | 8.4046605 × 1017 |
| Range | 8.4046605 × 1017 |
| Interquartile range (IQR) | 6.305016 × 1017 |
Descriptive statistics
| Standard deviation | 3.344213 × 1017 |
|---|---|
| Coefficient of variation (CV) | 1.5045233 |
| Kurtosis | -1.1494006 |
| Mean | 2.2227724 × 1017 |
| Median Absolute Deviation (MAD) | 29842097 |
| Skewness | 0.87882551 |
| Sum | 5.6176987 × 1018 |
| Variance | 1.1183761 × 1035 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2595 | 1 | < 0.1% |
| 53574639 | 1 | < 0.1% |
| 53605871 | 1 | < 0.1% |
| 53605960 | 1 | < 0.1% |
| 53606101 | 1 | < 0.1% |
| 53606289 | 1 | < 0.1% |
| 53575004 | 1 | < 0.1% |
| 53606306 | 1 | < 0.1% |
| 53606376 | 1 | < 0.1% |
| 53606452 | 1 | < 0.1% |
| Other values (42921) | 42921 |
| Value | Count | Frequency (%) |
| 2595 | 1 | |
| 5121 | 1 | |
| 5136 | 1 | |
| 5178 | 1 | |
| 5203 | 1 | |
| 5586 | 1 | |
| 5803 | 1 | |
| 6848 | 1 | |
| 6872 | 1 | |
| 6990 | 1 |
| Value | Count | Frequency (%) |
| 8.404660471 × 1017 | 1 | |
| 8.402288788 × 1017 | 1 | |
| 8.401503224 × 1017 | 1 | |
| 8.400804342 × 1017 | 1 | |
| 8.40049771 × 1017 | 1 | |
| 8.400478127 × 1017 | 1 | |
| 8.400315504 × 1017 | 1 | |
| 8.399770476 × 1017 | 1 | |
| 8.39959564 × 1017 | 1 | |
| 8.399557651 × 1017 | 1 |
name
Text
| Distinct | 41408 |
|---|---|
| Distinct (%) | 96.5% |
| Missing | 12 |
| Missing (%) | < 0.1% |
| Memory size | 335.5 KiB |
Length
| Max length | 248 |
|---|---|
| Median length | 114 |
| Mean length | 37.643794 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1615634 |
|---|---|
| Distinct characters | 838 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 40591 ? |
|---|---|
| Unique (%) | 94.6% |
Sample
| 1st row | Skylit Midtown Castle |
|---|---|
| 2nd row | BlissArtsSpace! |
| 3rd row | Cozy Clean Guest Room - Family Apt |
| 4th row | Large Furnished Room Near B'way  |
| 5th row | Large Sunny Brooklyn Duplex, Patio + Garden |
| Value | Count | Frequency (%) |
| in | 13926 | 5.2% |
| room | 7890 | 2.9% |
| 7235 | 2.7% | |
| bedroom | 7142 | 2.7% |
| private | 6183 | 2.3% |
| apartment | 5696 | 2.1% |
| cozy | 4040 | 1.5% |
| studio | 3712 | 1.4% |
| apt | 3629 | 1.3% |
| the | 3612 | 1.3% |
| Other values (12721) | 206018 |
Most occurring characters
| Value | Count | Frequency (%) |
| 227633 | 14.1% | |
| e | 118241 | 7.3% |
| o | 112670 | 7.0% |
| t | 94796 | 5.9% |
| a | 91102 | 5.6% |
| r | 88976 | 5.5% |
| n | 84848 | 5.3% |
| i | 84620 | 5.2% |
| l | 46838 | 2.9% |
| m | 43858 | 2.7% |
| Other values (828) | 622052 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1615634 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 227633 | 14.1% | |
| e | 118241 | 7.3% |
| o | 112670 | 7.0% |
| t | 94796 | 5.9% |
| a | 91102 | 5.6% |
| r | 88976 | 5.5% |
| n | 84848 | 5.3% |
| i | 84620 | 5.2% |
| l | 46838 | 2.9% |
| m | 43858 | 2.7% |
| Other values (828) | 622052 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1615634 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 227633 | 14.1% | |
| e | 118241 | 7.3% |
| o | 112670 | 7.0% |
| t | 94796 | 5.9% |
| a | 91102 | 5.6% |
| r | 88976 | 5.5% |
| n | 84848 | 5.3% |
| i | 84620 | 5.2% |
| l | 46838 | 2.9% |
| m | 43858 | 2.7% |
| Other values (828) | 622052 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1615634 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 227633 | 14.1% | |
| e | 118241 | 7.3% |
| o | 112670 | 7.0% |
| t | 94796 | 5.9% |
| a | 91102 | 5.6% |
| r | 88976 | 5.5% |
| n | 84848 | 5.3% |
| i | 84620 | 5.2% |
| l | 46838 | 2.9% |
| m | 43858 | 2.7% |
| Other values (828) | 622052 |
host_id
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 27455 |
|---|---|
| Distinct (%) | 64.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.5160121 × 108 |
| Minimum | 1678 |
|---|---|
| Maximum | 5.0387289 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 335.5 KiB |
Quantile statistics
| Minimum | 1678 |
|---|---|
| 5-th percentile | 1398639 |
| Q1 | 16085328 |
| median | 74338125 |
| Q3 | 2.6806924 × 108 |
| 95-th percentile | 4.7498775 × 108 |
| Maximum | 5.0387289 × 108 |
| Range | 5.0387121 × 108 |
| Interquartile range (IQR) | 2.5198391 × 108 |
Descriptive statistics
| Standard deviation | 1.6213011 × 108 |
|---|---|
| Coefficient of variation (CV) | 1.0694513 |
| Kurtosis | -0.70164463 |
| Mean | 1.5160121 × 108 |
| Median Absolute Deviation (MAD) | 70621479 |
| Skewness | 0.86158061 |
| Sum | 6.5083915 × 1012 |
| Variance | 2.6286172 × 1016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 107434423 | 526 | 1.2% |
| 3223938 | 394 | 0.9% |
| 496944100 | 356 | 0.8% |
| 305240193 | 222 | 0.5% |
| 19303369 | 207 | 0.5% |
| 200239515 | 192 | 0.4% |
| 204704622 | 178 | 0.4% |
| 162280872 | 159 | 0.4% |
| 51501835 | 131 | 0.3% |
| 137358866 | 124 | 0.3% |
| Other values (27445) | 40442 |
| Value | Count | Frequency (%) |
| 1678 | 1 | < 0.1% |
| 2234 | 1 | < 0.1% |
| 2438 | 1 | < 0.1% |
| 2571 | 1 | < 0.1% |
| 2782 | 1 | < 0.1% |
| 2787 | 7 | |
| 2845 | 3 | |
| 2868 | 1 | < 0.1% |
| 3647 | 1 | < 0.1% |
| 3757 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 503872891 | 1 | |
| 503757175 | 1 | |
| 503726515 | 1 | |
| 503718879 | 1 | |
| 503593397 | 1 | |
| 503579221 | 1 | |
| 503563559 | 1 | |
| 503556906 | 1 | |
| 503542653 | 1 | |
| 503540971 | 1 |
host_name
Text
| Distinct | 9831 |
|---|---|
| Distinct (%) | 22.9% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Memory size | 335.5 KiB |
Length
| Max length | 35 |
|---|---|
| Median length | 33 |
| Mean length | 6.5092951 |
| Min length | 1 |
Characters and Unicode
| Total characters | 279418 |
|---|---|
| Distinct characters | 151 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5667 ? |
|---|---|
| Unique (%) | 13.2% |
Sample
| 1st row | Jennifer |
|---|---|
| 2nd row | Garon |
| 3rd row | MaryEllen |
| 4th row | Shunichi |
| 5th row | Rebecca |
| Value | Count | Frequency (%) |
| 614 | 1.3% | |
| roompicks | 608 | 1.2% |
| blueground | 526 | 1.1% |
| and | 497 | 1.0% |
| eugene | 400 | 0.8% |
| michael | 346 | 0.7% |
| david | 326 | 0.7% |
| alex | 256 | 0.5% |
| kristina | 256 | 0.5% |
| by | 233 | 0.5% |
| Other values (9170) | 44983 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 32451 | 11.6% |
| e | 26336 | 9.4% |
| i | 22166 | 7.9% |
| n | 22036 | 7.9% |
| r | 16248 | 5.8% |
| o | 14270 | 5.1% |
| l | 13690 | 4.9% |
| s | 9277 | 3.3% |
| t | 9041 | 3.2% |
| h | 8220 | 2.9% |
| Other values (141) | 105683 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 279418 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 32451 | 11.6% |
| e | 26336 | 9.4% |
| i | 22166 | 7.9% |
| n | 22036 | 7.9% |
| r | 16248 | 5.8% |
| o | 14270 | 5.1% |
| l | 13690 | 4.9% |
| s | 9277 | 3.3% |
| t | 9041 | 3.2% |
| h | 8220 | 2.9% |
| Other values (141) | 105683 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 279418 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 32451 | 11.6% |
| e | 26336 | 9.4% |
| i | 22166 | 7.9% |
| n | 22036 | 7.9% |
| r | 16248 | 5.8% |
| o | 14270 | 5.1% |
| l | 13690 | 4.9% |
| s | 9277 | 3.3% |
| t | 9041 | 3.2% |
| h | 8220 | 2.9% |
| Other values (141) | 105683 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 279418 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 32451 | 11.6% |
| e | 26336 | 9.4% |
| i | 22166 | 7.9% |
| n | 22036 | 7.9% |
| r | 16248 | 5.8% |
| o | 14270 | 5.1% |
| l | 13690 | 4.9% |
| s | 9277 | 3.3% |
| t | 9041 | 3.2% |
| h | 8220 | 2.9% |
| Other values (141) | 105683 |
neighbourhood_group
Categorical
HIGH CORRELATION 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 335.5 KiB |
| Manhattan | |
|---|---|
| Brooklyn | |
| Queens | |
| Bronx | 1691 |
| Staten Island | 429 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 8.0209173 |
| Min length | 5 |
Characters and Unicode
| Total characters | 344346 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Manhattan |
|---|---|
| 2nd row | Brooklyn |
| 3rd row | Manhattan |
| 4th row | Manhattan |
| 5th row | Brooklyn |
Common Values
| Value | Count | Frequency (%) |
| Manhattan | 17658 | |
| Brooklyn | 16237 | |
| Queens | 6916 | 16.1% |
| Bronx | 1691 | 3.9% |
| Staten Island | 429 | 1.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| manhattan | 17658 | |
| brooklyn | 16237 | |
| queens | 6916 | 16.0% |
| bronx | 1691 | 3.9% |
| staten | 429 | 1.0% |
| island | 429 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 61018 | |
| a | 53832 | |
| t | 36174 | |
| o | 34165 | |
| B | 17928 | 5.2% |
| r | 17928 | 5.2% |
| M | 17658 | 5.1% |
| h | 17658 | 5.1% |
| l | 16666 | 4.8% |
| y | 16237 | 4.7% |
| Other values (10) | 55082 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 344346 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 61018 | |
| a | 53832 | |
| t | 36174 | |
| o | 34165 | |
| B | 17928 | 5.2% |
| r | 17928 | 5.2% |
| M | 17658 | 5.1% |
| h | 17658 | 5.1% |
| l | 16666 | 4.8% |
| y | 16237 | 4.7% |
| Other values (10) | 55082 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 344346 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 61018 | |
| a | 53832 | |
| t | 36174 | |
| o | 34165 | |
| B | 17928 | 5.2% |
| r | 17928 | 5.2% |
| M | 17658 | 5.1% |
| h | 17658 | 5.1% |
| l | 16666 | 4.8% |
| y | 16237 | 4.7% |
| Other values (10) | 55082 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 344346 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 61018 | |
| a | 53832 | |
| t | 36174 | |
| o | 34165 | |
| B | 17928 | 5.2% |
| r | 17928 | 5.2% |
| M | 17658 | 5.1% |
| h | 17658 | 5.1% |
| l | 16666 | 4.8% |
| y | 16237 | 4.7% |
| Other values (10) | 55082 |
neighbourhood
Text
| Distinct | 223 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 335.5 KiB |
Length
| Max length | 25 |
|---|---|
| Median length | 17 |
| Mean length | 11.700147 |
| Min length | 4 |
Characters and Unicode
| Total characters | 502299 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Midtown |
|---|---|
| 2nd row | Bedford-Stuyvesant |
| 3rd row | Upper West Side |
| 4th row | Midtown |
| 5th row | Sunset Park |
| Value | Count | Frequency (%) |
| east | 5412 | 7.9% |
| side | 3673 | 5.3% |
| bedford-stuyvesant | 3086 | 4.5% |
| upper | 2973 | 4.3% |
| harlem | 2935 | 4.3% |
| heights | 2914 | 4.2% |
| williamsburg | 2597 | 3.8% |
| midtown | 2182 | 3.2% |
| village | 2116 | 3.1% |
| west | 2110 | 3.1% |
| Other values (236) | 38922 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 45003 | 9.0% |
| i | 35535 | 7.1% |
| s | 34196 | 6.8% |
| t | 34054 | 6.8% |
| a | 33155 | 6.6% |
| r | 28945 | 5.8% |
| l | 28068 | 5.6% |
| 25989 | 5.2% | |
| n | 23566 | 4.7% |
| o | 22306 | 4.4% |
| Other values (44) | 191482 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 502299 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 45003 | 9.0% |
| i | 35535 | 7.1% |
| s | 34196 | 6.8% |
| t | 34054 | 6.8% |
| a | 33155 | 6.6% |
| r | 28945 | 5.8% |
| l | 28068 | 5.6% |
| 25989 | 5.2% | |
| n | 23566 | 4.7% |
| o | 22306 | 4.4% |
| Other values (44) | 191482 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 502299 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 45003 | 9.0% |
| i | 35535 | 7.1% |
| s | 34196 | 6.8% |
| t | 34054 | 6.8% |
| a | 33155 | 6.6% |
| r | 28945 | 5.8% |
| l | 28068 | 5.6% |
| 25989 | 5.2% | |
| n | 23566 | 4.7% |
| o | 22306 | 4.4% |
| Other values (44) | 191482 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 502299 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 45003 | 9.0% |
| i | 35535 | 7.1% |
| s | 34196 | 6.8% |
| t | 34054 | 6.8% |
| a | 33155 | 6.6% |
| r | 28945 | 5.8% |
| l | 28068 | 5.6% |
| 25989 | 5.2% | |
| n | 23566 | 4.7% |
| o | 22306 | 4.4% |
| Other values (44) | 191482 |
latitude
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 22673 |
|---|---|
| Distinct (%) | 52.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.728273 |
| Minimum | 40.500314 |
|---|---|
| Maximum | 40.91138 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 335.5 KiB |
Quantile statistics
| Minimum | 40.500314 |
|---|---|
| 5-th percentile | 40.640268 |
| Q1 | 40.687485 |
| median | 40.72404 |
| Q3 | 40.762293 |
| 95-th percentile | 40.82956 |
| Maximum | 40.91138 |
| Range | 0.41106557 |
| Interquartile range (IQR) | 0.074808455 |
Descriptive statistics
| Standard deviation | 0.057640457 |
|---|---|
| Coefficient of variation (CV) | 0.0014152443 |
| Kurtosis | 0.13647495 |
| Mean | 40.728273 |
| Median Absolute Deviation (MAD) | 0.03747 |
| Skewness | 0.2179238 |
| Sum | 1748505.5 |
| Variance | 0.0033224223 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.76153 | 52 | 0.1% |
| 40.76411 | 32 | 0.1% |
| 40.760452 | 24 | 0.1% |
| 40.761532 | 22 | 0.1% |
| 40.7607614 | 22 | 0.1% |
| 40.73756 | 19 | < 0.1% |
| 40.75436 | 19 | < 0.1% |
| 40.71899 | 18 | < 0.1% |
| 40.74926 | 17 | < 0.1% |
| 40.71579 | 17 | < 0.1% |
| Other values (22663) | 42689 |
| Value | Count | Frequency (%) |
| 40.50031443 | 1 | |
| 40.50456 | 1 | |
| 40.507114 | 1 | |
| 40.50848895 | 1 | |
| 40.50863 | 1 | |
| 40.52034 | 1 | |
| 40.52224 | 1 | |
| 40.52339 | 1 | |
| 40.52498 | 1 | |
| 40.53125 | 1 |
| Value | Count | Frequency (%) |
| 40.91138 | 1 | |
| 40.91114684 | 1 | |
| 40.91062 | 1 | |
| 40.90884 | 1 | |
| 40.90530196 | 1 | |
| 40.90505 | 1 | |
| 40.90424 | 1 | |
| 40.90421 | 1 | |
| 40.90403 | 1 | |
| 40.90376 | 1 |
longitude
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 20130 |
|---|---|
| Distinct (%) | 46.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.943665 |
| Minimum | -74.251907 |
|---|---|
| Maximum | -73.71087 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 42931 |
| Negative (%) | 100.0% |
| Memory size | 335.5 KiB |
Quantile statistics
| Minimum | -74.251907 |
|---|---|
| 5-th percentile | -74.003735 |
| Q1 | -73.98175 |
| median | -73.95262 |
| Q3 | -73.924035 |
| 95-th percentile | -73.820533 |
| Maximum | -73.71087 |
| Range | 0.541037 |
| Interquartile range (IQR) | 0.057715 |
Descriptive statistics
| Standard deviation | 0.056626547 |
|---|---|
| Coefficient of variation (CV) | -0.0007658066 |
| Kurtosis | 3.0410896 |
| Mean | -73.943665 |
| Median Absolute Deviation (MAD) | 0.02895 |
| Skewness | 1.1475906 |
| Sum | -3174475.5 |
| Variance | 0.0032065658 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -73.99878 | 52 | 0.1% |
| -73.99371 | 30 | 0.1% |
| -73.99391 | 24 | 0.1% |
| -73.76606 | 24 | 0.1% |
| -73.97643 | 24 | 0.1% |
| -73.9861055 | 22 | 0.1% |
| -74.00587 | 22 | 0.1% |
| -73.998779 | 22 | 0.1% |
| -73.9535 | 20 | < 0.1% |
| -73.98698 | 18 | < 0.1% |
| Other values (20120) | 42673 |
| Value | Count | Frequency (%) |
| -74.251907 | 1 | |
| -74.24984 | 1 | |
| -74.24308594 | 1 | |
| -74.24135 | 1 | |
| -74.23913565 | 1 | |
| -74.21514 | 1 | |
| -74.21126 | 1 | |
| -74.21088 | 1 | |
| -74.21065716 | 1 | |
| -74.20739 | 1 |
| Value | Count | Frequency (%) |
| -73.71087 | 1 | |
| -73.71299 | 1 | |
| -73.71439 | 1 | |
| -73.7174099 | 1 | |
| -73.71974787 | 1 | |
| -73.71991 | 1 | |
| -73.72054 | 1 | |
| -73.7216024 | 1 | |
| -73.72408 | 1 | |
| -73.72434 | 1 |
room_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 335.5 KiB |
| Entire home/apt | |
|---|---|
| Private room | |
| Shared room | 576 |
| Hotel room | 197 |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 13.674012 |
| Min length | 10 |
Characters and Unicode
| Total characters | 587039 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Entire home/apt |
|---|---|
| 2nd row | Private room |
| 3rd row | Private room |
| 4th row | Private room |
| 5th row | Entire home/apt |
Common Values
| Value | Count | Frequency (%) |
| Entire home/apt | 24279 | |
| Private room | 17879 | |
| Shared room | 576 | 1.3% |
| Hotel room | 197 | 0.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| entire | 24279 | |
| home/apt | 24279 | |
| room | 18652 | |
| private | 17879 | |
| shared | 576 | 0.7% |
| hotel | 197 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 67210 | |
| t | 66634 | |
| o | 61780 | |
| r | 61386 | |
| m | 42931 | 7.3% |
| 42931 | 7.3% | |
| a | 42734 | 7.3% |
| i | 42158 | 7.2% |
| h | 24855 | 4.2% |
| p | 24279 | 4.1% |
| Other values (9) | 110141 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 587039 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 67210 | |
| t | 66634 | |
| o | 61780 | |
| r | 61386 | |
| m | 42931 | 7.3% |
| 42931 | 7.3% | |
| a | 42734 | 7.3% |
| i | 42158 | 7.2% |
| h | 24855 | 4.2% |
| p | 24279 | 4.1% |
| Other values (9) | 110141 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 587039 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 67210 | |
| t | 66634 | |
| o | 61780 | |
| r | 61386 | |
| m | 42931 | 7.3% |
| 42931 | 7.3% | |
| a | 42734 | 7.3% |
| i | 42158 | 7.2% |
| h | 24855 | 4.2% |
| p | 24279 | 4.1% |
| Other values (9) | 110141 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 587039 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 67210 | |
| t | 66634 | |
| o | 61780 | |
| r | 61386 | |
| m | 42931 | 7.3% |
| 42931 | 7.3% | |
| a | 42734 | 7.3% |
| i | 42158 | 7.2% |
| h | 24855 | 4.2% |
| p | 24279 | 4.1% |
| Other values (9) | 110141 |
price
Real number (ℝ)
SKEWED 
| Distinct | 1089 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 200.30717 |
| Minimum | 0 |
|---|---|
| Maximum | 99000 |
| Zeros | 27 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 335.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 75 |
| median | 125 |
| Q3 | 200 |
| 95-th percentile | 499 |
| Maximum | 99000 |
| Range | 99000 |
| Interquartile range (IQR) | 125 |
Descriptive statistics
| Standard deviation | 895.08291 |
|---|---|
| Coefficient of variation (CV) | 4.4685516 |
| Kurtosis | 7897.8051 |
| Mean | 200.30717 |
| Median Absolute Deviation (MAD) | 59 |
| Skewness | 81.454491 |
| Sum | 8599387 |
| Variance | 801173.42 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 150 | 1254 | 2.9% |
| 100 | 1144 | 2.7% |
| 200 | 886 | 2.1% |
| 120 | 784 | 1.8% |
| 60 | 765 | 1.8% |
| 75 | 746 | 1.7% |
| 50 | 736 | 1.7% |
| 80 | 728 | 1.7% |
| 70 | 697 | 1.6% |
| 90 | 691 | 1.6% |
| Other values (1079) | 34500 |
| Value | Count | Frequency (%) |
| 0 | 27 | |
| 10 | 7 | < 0.1% |
| 15 | 2 | < 0.1% |
| 16 | 3 | < 0.1% |
| 18 | 2 | < 0.1% |
| 19 | 5 | < 0.1% |
| 20 | 18 | |
| 21 | 3 | < 0.1% |
| 22 | 15 | |
| 23 | 18 |
| Value | Count | Frequency (%) |
| 99000 | 1 | < 0.1% |
| 85170 | 1 | < 0.1% |
| 85100 | 1 | < 0.1% |
| 65115 | 1 | < 0.1% |
| 20500 | 1 | < 0.1% |
| 19750 | 1 | < 0.1% |
| 15000 | 1 | < 0.1% |
| 10000 | 9 | |
| 9999 | 4 | |
| 9994 | 1 | < 0.1% |
minimum_nights
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 128 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.111178 |
| Minimum | 1 |
|---|---|
| Maximum | 1250 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 335.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 7 |
| Q3 | 30 |
| 95-th percentile | 30 |
| Maximum | 1250 |
| Range | 1249 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 27.462513 |
|---|---|
| Coefficient of variation (CV) | 1.5163294 |
| Kurtosis | 334.65305 |
| Mean | 18.111178 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 12.426192 |
| Sum | 777531 |
| Variance | 754.18962 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 30 | 18235 | |
| 1 | 7946 | |
| 2 | 5524 | 12.9% |
| 3 | 3814 | 8.9% |
| 5 | 1499 | 3.5% |
| 4 | 1422 | 3.3% |
| 7 | 922 | 2.1% |
| 31 | 786 | 1.8% |
| 90 | 472 | 1.1% |
| 6 | 370 | 0.9% |
| Other values (118) | 1941 | 4.5% |
| Value | Count | Frequency (%) |
| 1 | 7946 | |
| 2 | 5524 | |
| 3 | 3814 | |
| 4 | 1422 | 3.3% |
| 5 | 1499 | 3.5% |
| 6 | 370 | 0.9% |
| 7 | 922 | 2.1% |
| 8 | 53 | 0.1% |
| 9 | 27 | 0.1% |
| 10 | 218 | 0.5% |
| Value | Count | Frequency (%) |
| 1250 | 1 | < 0.1% |
| 1124 | 1 | < 0.1% |
| 1000 | 2 | < 0.1% |
| 999 | 1 | < 0.1% |
| 500 | 6 | < 0.1% |
| 480 | 1 | < 0.1% |
| 400 | 3 | < 0.1% |
| 370 | 1 | < 0.1% |
| 366 | 1 | < 0.1% |
| 365 | 51 |
number_of_reviews
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 476 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.856001 |
| Minimum | 0 |
|---|---|
| Maximum | 1842 |
| Zeros | 10304 |
| Zeros (%) | 24.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 335.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 5 |
| Q3 | 24 |
| 95-th percentile | 129 |
| Maximum | 1842 |
| Range | 1842 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 56.616344 |
|---|---|
| Coefficient of variation (CV) | 2.189679 |
| Kurtosis | 73.000382 |
| Mean | 25.856001 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 5.7317373 |
| Sum | 1110024 |
| Variance | 3205.4104 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 10304 | |
| 1 | 4410 | 10.3% |
| 2 | 2894 | 6.7% |
| 3 | 2052 | 4.8% |
| 4 | 1577 | 3.7% |
| 5 | 1289 | 3.0% |
| 6 | 1110 | 2.6% |
| 7 | 1002 | 2.3% |
| 8 | 813 | 1.9% |
| 9 | 751 | 1.7% |
| Other values (466) | 16729 |
| Value | Count | Frequency (%) |
| 0 | 10304 | |
| 1 | 4410 | |
| 2 | 2894 | 6.7% |
| 3 | 2052 | 4.8% |
| 4 | 1577 | 3.7% |
| 5 | 1289 | 3.0% |
| 6 | 1110 | 2.6% |
| 7 | 1002 | 2.3% |
| 8 | 813 | 1.9% |
| 9 | 751 | 1.7% |
| Value | Count | Frequency (%) |
| 1842 | 1 | |
| 1642 | 1 | |
| 1097 | 1 | |
| 1010 | 1 | |
| 985 | 1 | |
| 948 | 1 | |
| 917 | 1 | |
| 798 | 1 | |
| 789 | 1 | |
| 766 | 1 |
last_review
Date
MISSING 
| Distinct | 2795 |
|---|---|
| Distinct (%) | 8.6% |
| Missing | 10304 |
| Missing (%) | 24.0% |
| Memory size | 335.5 KiB |
| Minimum | 2011-05-12 00:00:00 |
|---|---|
| Maximum | 2023-03-06 00:00:00 |
reviews_per_month
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 881 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 10304 |
| Missing (%) | 24.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1689883 |
| Minimum | 0.01 |
|---|---|
| Maximum | 86.61 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 335.5 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.02 |
| Q1 | 0.14 |
| median | 0.52 |
| Q3 | 1.67 |
| 95-th percentile | 4.09 |
| Maximum | 86.61 |
| Range | 86.6 |
| Interquartile range (IQR) | 1.53 |
Descriptive statistics
| Standard deviation | 1.7896749 |
|---|---|
| Coefficient of variation (CV) | 1.5309605 |
| Kurtosis | 302.80799 |
| Mean | 1.1689883 |
| Median Absolute Deviation (MAD) | 0.47 |
| Skewness | 10.30231 |
| Sum | 38140.58 |
| Variance | 3.2029362 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.02 | 1063 | 2.5% |
| 0.01 | 965 | 2.2% |
| 0.03 | 826 | 1.9% |
| 0.05 | 779 | 1.8% |
| 0.04 | 722 | 1.7% |
| 0.07 | 595 | 1.4% |
| 0.06 | 514 | 1.2% |
| 0.1 | 493 | 1.1% |
| 1 | 476 | 1.1% |
| 0.08 | 466 | 1.1% |
| Other values (871) | 25728 | |
| (Missing) | 10304 |
| Value | Count | Frequency (%) |
| 0.01 | 965 | |
| 0.02 | 1063 | |
| 0.03 | 826 | |
| 0.04 | 722 | |
| 0.05 | 779 | |
| 0.06 | 514 | |
| 0.07 | 595 | |
| 0.08 | 466 | |
| 0.09 | 459 | |
| 0.1 | 493 |
| Value | Count | Frequency (%) |
| 86.61 | 1 | |
| 61.26 | 1 | |
| 55.46 | 1 | |
| 51.71 | 1 | |
| 45.53 | 1 | |
| 43.75 | 1 | |
| 40.78 | 1 | |
| 36.94 | 1 | |
| 35.96 | 1 | |
| 33.81 | 1 |
calculated_host_listings_count
Real number (ℝ)
| Distinct | 65 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.054809 |
| Minimum | 1 |
|---|---|
| Maximum | 526 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 335.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 4 |
| 95-th percentile | 159 |
| Maximum | 526 |
| Range | 525 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 80.867958 |
|---|---|
| Coefficient of variation (CV) | 3.3618209 |
| Kurtosis | 22.085603 |
| Mean | 24.054809 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.6167703 |
| Sum | 1032697 |
| Variance | 6539.6266 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 22528 | |
| 2 | 5666 | 13.2% |
| 3 | 2814 | 6.6% |
| 4 | 1740 | 4.1% |
| 5 | 1020 | 2.4% |
| 6 | 768 | 1.8% |
| 8 | 560 | 1.3% |
| 7 | 546 | 1.3% |
| 526 | 526 | 1.2% |
| 394 | 394 | 0.9% |
| Other values (55) | 6369 | 14.8% |
| Value | Count | Frequency (%) |
| 1 | 22528 | |
| 2 | 5666 | 13.2% |
| 3 | 2814 | 6.6% |
| 4 | 1740 | 4.1% |
| 5 | 1020 | 2.4% |
| 6 | 768 | 1.8% |
| 7 | 546 | 1.3% |
| 8 | 560 | 1.3% |
| 9 | 315 | 0.7% |
| 10 | 320 | 0.7% |
| Value | Count | Frequency (%) |
| 526 | 526 | |
| 394 | 394 | |
| 356 | 356 | |
| 222 | 222 | |
| 207 | 207 | 0.5% |
| 192 | 192 | 0.4% |
| 178 | 178 | 0.4% |
| 159 | 159 | 0.4% |
| 131 | 131 | 0.3% |
| 124 | 248 |
number_of_reviews_ltm
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 168 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.7365074 |
| Minimum | 0 |
|---|---|
| Maximum | 1093 |
| Zeros | 21470 |
| Zeros (%) | 50.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 335.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 7 |
| 95-th percentile | 40 |
| Maximum | 1093 |
| Range | 1093 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 18.290256 |
|---|---|
| Coefficient of variation (CV) | 2.3641489 |
| Kurtosis | 584.39757 |
| Mean | 7.7365074 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 14.547605 |
| Sum | 332136 |
| Variance | 334.53346 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 21470 | |
| 1 | 3377 | 7.9% |
| 2 | 2238 | 5.2% |
| 3 | 1711 | 4.0% |
| 4 | 1226 | 2.9% |
| 5 | 956 | 2.2% |
| 6 | 755 | 1.8% |
| 7 | 628 | 1.5% |
| 8 | 532 | 1.2% |
| 10 | 479 | 1.1% |
| Other values (158) | 9559 |
| Value | Count | Frequency (%) |
| 0 | 21470 | |
| 1 | 3377 | 7.9% |
| 2 | 2238 | 5.2% |
| 3 | 1711 | 4.0% |
| 4 | 1226 | 2.9% |
| 5 | 956 | 2.2% |
| 6 | 755 | 1.8% |
| 7 | 628 | 1.5% |
| 8 | 532 | 1.2% |
| 9 | 457 | 1.1% |
| Value | Count | Frequency (%) |
| 1093 | 1 | |
| 889 | 1 | |
| 770 | 1 | |
| 668 | 1 | |
| 530 | 1 | |
| 458 | 1 | |
| 442 | 1 | |
| 379 | 1 | |
| 368 | 1 | |
| 354 | 1 |
MISSING 
| Distinct | 50 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 42881 |
| Missing (%) | 99.9% |
| Memory size | 335.5 KiB |
Length
| Max length | 87 |
|---|---|
| Median length | 76 |
| Mean length | 65.38 |
| Min length | 56 |
Characters and Unicode
| Total characters | 3269 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 50 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 104 West 40th Street, New York, NY 10018, United States of America |
|---|---|
| 2nd row | 294 Gates Avenue, New York, NY 11216, United States of America |
| 3rd row | 301 West 109th Street, New York, NY 10025, United States of America |
| 4th row | Hilton Garden Inn, 237 West 54th Street, New York, NY 10019, United States of America |
| 5th row | Al-Noor School, 675 4th Avenue, New York, NY 11232, United States of America |
| Value | Count | Frequency (%) |
| new | 50 | 8.7% |
| york | 50 | 8.7% |
| ny | 50 | 8.7% |
| united | 50 | 8.7% |
| states | 50 | 8.7% |
| of | 50 | 8.7% |
| america | 50 | 8.7% |
| street | 31 | 5.4% |
| avenue | 16 | 2.8% |
| west | 13 | 2.2% |
| Other values (142) | 168 |
Most occurring characters
| Value | Count | Frequency (%) |
| 528 | ||
| e | 332 | 10.2% |
| t | 269 | 8.2% |
| , | 155 | 4.7% |
| r | 149 | 4.6% |
| 1 | 139 | 4.3% |
| o | 125 | 3.8% |
| a | 121 | 3.7% |
| i | 107 | 3.3% |
| N | 102 | 3.1% |
| Other values (47) | 1242 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3269 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 528 | ||
| e | 332 | 10.2% |
| t | 269 | 8.2% |
| , | 155 | 4.7% |
| r | 149 | 4.6% |
| 1 | 139 | 4.3% |
| o | 125 | 3.8% |
| a | 121 | 3.7% |
| i | 107 | 3.3% |
| N | 102 | 3.1% |
| Other values (47) | 1242 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3269 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 528 | ||
| e | 332 | 10.2% |
| t | 269 | 8.2% |
| , | 155 | 4.7% |
| r | 149 | 4.6% |
| 1 | 139 | 4.3% |
| o | 125 | 3.8% |
| a | 121 | 3.7% |
| i | 107 | 3.3% |
| N | 102 | 3.1% |
| Other values (47) | 1242 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3269 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 528 | ||
| e | 332 | 10.2% |
| t | 269 | 8.2% |
| , | 155 | 4.7% |
| r | 149 | 4.6% |
| 1 | 139 | 4.3% |
| o | 125 | 3.8% |
| a | 121 | 3.7% |
| i | 107 | 3.3% |
| N | 102 | 3.1% |
| Other values (47) | 1242 |
| calculated_host_listings_count | host_id | id | latitude | longitude | minimum_nights | neighbourhood_group | number_of_reviews | number_of_reviews_ltm | price | reviews_per_month | room_type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| calculated_host_listings_count | 1.000 | 0.251 | 0.328 | 0.089 | -0.005 | -0.051 | 0.149 | -0.117 | 0.063 | -0.049 | 0.130 | 0.110 |
| host_id | 0.251 | 1.000 | 0.542 | 0.046 | 0.125 | -0.311 | 0.111 | -0.102 | 0.148 | 0.019 | 0.309 | 0.104 |
| id | 0.328 | 0.542 | 1.000 | 0.001 | 0.096 | -0.365 | 0.057 | -0.333 | 0.156 | 0.114 | 0.430 | 0.033 |
| latitude | 0.089 | 0.046 | 0.001 | 1.000 | 0.011 | 0.061 | 0.558 | -0.075 | -0.080 | 0.081 | -0.074 | 0.084 |
| longitude | -0.005 | 0.125 | 0.096 | 0.011 | 1.000 | -0.149 | 0.680 | 0.102 | 0.151 | -0.390 | 0.176 | 0.112 |
| minimum_nights | -0.051 | -0.311 | -0.365 | 0.061 | -0.149 | 1.000 | 0.008 | -0.302 | -0.525 | -0.149 | -0.622 | 0.018 |
| neighbourhood_group | 0.149 | 0.111 | 0.057 | 0.558 | 0.680 | 0.008 | 1.000 | -0.034 | -0.004 | 0.061 | 0.024 | 0.094 |
| number_of_reviews | -0.117 | -0.102 | -0.333 | -0.075 | 0.102 | -0.302 | -0.034 | 1.000 | 0.698 | -0.025 | 0.699 | 0.043 |
| number_of_reviews_ltm | 0.063 | 0.148 | 0.156 | -0.080 | 0.151 | -0.525 | -0.004 | 0.698 | 1.000 | 0.055 | 0.834 | 0.023 |
| price | -0.049 | 0.019 | 0.114 | 0.081 | -0.390 | -0.149 | 0.061 | -0.025 | 0.055 | 1.000 | 0.090 | 0.000 |
| reviews_per_month | 0.130 | 0.309 | 0.430 | -0.074 | 0.176 | -0.622 | 0.024 | 0.699 | 0.834 | 0.090 | 1.000 | 0.033 |
| room_type | 0.110 | 0.104 | 0.033 | 0.084 | 0.112 | 0.018 | 0.094 | 0.043 | 0.023 | 0.000 | 0.033 | 1.000 |
| id | name | host_id | host_name | neighbourhood_group | neighbourhood | latitude | longitude | room_type | price | minimum_nights | number_of_reviews | last_review | reviews_per_month | calculated_host_listings_count | number_of_reviews_ltm | detailed_location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2595 | Skylit Midtown Castle | 2845 | Jennifer | Manhattan | Midtown | 40.75356 | -73.98559 | Entire home/apt | 150 | 30 | 49 | 2022-06-21 | 0.30 | 3 | 1 | 104 West 40th Street, New York, NY 10018, United States of America |
| 1 | 5121 | BlissArtsSpace! | 7356 | Garon | Brooklyn | Bedford-Stuyvesant | 40.68535 | -73.95512 | Private room | 60 | 30 | 50 | 2019-12-02 | 0.30 | 2 | 0 | 294 Gates Avenue, New York, NY 11216, United States of America |
| 2 | 5203 | Cozy Clean Guest Room - Family Apt | 7490 | MaryEllen | Manhattan | Upper West Side | 40.80380 | -73.96751 | Private room | 75 | 2 | 118 | 2017-07-21 | 0.72 | 1 | 0 | 301 West 109th Street, New York, NY 10025, United States of America |
| 3 | 5178 | Large Furnished Room Near B'way | 8967 | Shunichi | Manhattan | Midtown | 40.76457 | -73.98317 | Private room | 68 | 2 | 575 | 2023-02-19 | 3.41 | 1 | 52 | Hilton Garden Inn, 237 West 54th Street, New York, NY 10019, United States of America |
| 4 | 5136 | Large Sunny Brooklyn Duplex, Patio + Garden | 7378 | Rebecca | Brooklyn | Sunset Park | 40.66265 | -73.99454 | Entire home/apt | 275 | 60 | 3 | 2022-08-10 | 0.03 | 1 | 1 | Al-Noor School, 675 4th Avenue, New York, NY 11232, United States of America |
| 5 | 29628 | Comfortable, Sunny Room | 127608 | Chris | Brooklyn | Clinton Hill | 40.68292 | -73.96381 | Private room | 93 | 3 | 350 | 2023-02-27 | 2.25 | 1 | 48 | Fulton Street, New York, NY 11207, United States of America |
| 6 | 5586 | Rooftop Deck/City Views. Great Apt | 8526 | Susan | Manhattan | Upper East Side | 40.76076 | -73.96156 | Entire home/apt | 295 | 4 | 45 | 2022-10-03 | 0.27 | 1 | 4 | 1107 1st Avenue, New York, NY 10065, United States of America |
| 7 | 5803 | Lovely, Cozy, Room 1, BEST AREA; Legal Rental | 9744 | Laurie | Brooklyn | South Slope | 40.66801 | -73.98784 | Private room | 124 | 3 | 223 | 2023-02-13 | 1.32 | 3 | 17 | 318 11th Street, New York, NY 11215, United States of America |
| 8 | 31130 | Most Central Location! | 117287 | Lara Nicole | Manhattan | Hell's Kitchen | 40.76720 | -73.98464 | Private room | 200 | 1 | 68 | 2021-10-01 | 0.44 | 4 | 0 | West 57th Street, New York, NY 10019, United States of America |
| 9 | 6848 | Only 2 stops to Manhattan studio | 15991 | Allen & Irina | Brooklyn | Williamsburg | 40.70935 | -73.95342 | Entire home/apt | 81 | 30 | 189 | 2023-02-04 | 1.13 | 1 | 5 | 353 South 3rd Street, New York, NY 11211, United States of America |
| id | name | host_id | host_name | neighbourhood_group | neighbourhood | latitude | longitude | room_type | price | minimum_nights | number_of_reviews | last_review | reviews_per_month | calculated_host_listings_count | number_of_reviews_ltm | detailed_location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42921 | 839542253443554475 | Charming Private BD w/shared BR & Kitchen | 429095657 | Aurgho | Queens | Jackson Heights | 40.751823 | -73.892451 | Private room | 80 | 1 | 0 | NaN | NaN | 3 | 0 | NaN |
| 42922 | 839604405796522504 | Cozy clean room in Brooklyn | 272771643 | Analisa | Brooklyn | Bedford-Stuyvesant | 40.691720 | -73.945442 | Private room | 36 | 4 | 0 | NaN | NaN | 1 | 0 | NaN |
| 42923 | 839607315156742936 | Spacious private BD w/ shared BR & Kitchen | 429095657 | Aurgho | Queens | Jackson Heights | 40.753224 | -73.892610 | Private room | 96 | 1 | 0 | NaN | NaN | 3 | 0 | NaN |
| 42924 | 839655582695838383 | Room near jfk airport | 142852663 | Monika | Queens | South Ozone Park | 40.673400 | -73.806280 | Private room | 68 | 1 | 0 | NaN | NaN | 1 | 0 | NaN |
| 42925 | 839728752538060549 | North Slope 1 Bedroom 1 Bath | 452459370 | Lee | Brooklyn | Park Slope | 40.671510 | -73.979431 | Entire home/apt | 100 | 14 | 0 | NaN | NaN | 1 | 0 | NaN |
| 42926 | 839753193689829909 | bright studio in Williamsburg | 28057253 | Jean | Brooklyn | Williamsburg | 40.718976 | -73.963985 | Entire home/apt | 76 | 7 | 0 | NaN | NaN | 1 | 0 | NaN |
| 42927 | 839786573617495393 | Room in the heart of LES with Gym& Rooftop BBQ | 247439246 | Charlene | Manhattan | East Village | 40.721703 | -73.981473 | Private room | 32 | 30 | 0 | NaN | NaN | 5 | 0 | NaN |
| 42928 | 839797749155954018 | Fantastic 3BD apt in Brooklyn | 26349246 | Jose | Brooklyn | Bushwick | 40.688700 | -73.907650 | Entire home/apt | 127 | 3 | 0 | NaN | NaN | 8 | 0 | NaN |
| 42929 | 839814083143454171 | The Coziest Home | 48533809 | Remmy | Staten Island | Bull's Head | 40.616911 | -74.164652 | Entire home/apt | 280 | 1 | 0 | NaN | NaN | 1 | 0 | NaN |
| 42930 | 839817199240589949 | 378-2L-Red | 488616033 | Mikey | Brooklyn | Williamsburg | 40.713091 | -73.957205 | Private room | 78 | 90 | 0 | NaN | NaN | 69 | 0 | NaN |